Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles   Excel template (XLSX)
$75.00

Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel XLSX)

Excel (XLSX)

$75.00
This template was crafted by a Financial Modeler, Accountant, & Consultant with over 10+ years of experience in developing Real Estate Underwriting tools. He has served 750+ clients, from small family offices to billion-dollar corporations.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

VIDEO DEMO

JOINT VENTURE EXCEL DESCRIPTION

This product (Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles) is an Excel template (XLSX), which you can download immediately upon purchase.

This is a joint venture cash flow waterfall. The template is designed for the user to enter in distributable cash flow (contributions and distributions) per period and the math takes over from there based on defined hurdle rates and cash flow splits per hurdle.

These are often designed based on IRR hurdles, but for this, there is no IRR consideration. Rather, the cash flow distributions and promotional split rate to the GP is based on the cumulative cash flow that has been distributed to the LP. That defines when a hurdle has been met.

There are up to 6 hurdles that can be configured for up to 60 periods. The hurdles are based on the cumulative cash flow that has been distributed to the LP (limited partner/investor). If you are using this for an annual basis, simply delete any unused columns and the model will continue to work without issue.

A percentage for contributions is defined between the GP and LP for any cash outflows that happen across the periods. This logic is not easy to build, especially when automatically figuring out the right cash split when multiple hurdles are reached within the same period, meaning in period ‘x' you may split some of the cash 90/10 and then if the next hurdle is 80/20 and the 80/20 hurdle was beaten in that same period ‘x', then some cash is split at the next hurdle rate and so on.

There are many ways to utilize this logic. If you want to make it a hard preferred equity up until the first hurdle, simply enter 100%/0% until the initial investment is fully repaid, or you can structure the hurdle amounts however you want.

There are final exit IRR rates that will display for the LP and GP as well as some visualizations to make it more clear for how cash is split over time and when various hurdles are met.

The most common uses for such models are in real estate deals, oil and gas, as well as general business startups where the investor simply wants to base the amount of available cash flow they are owed to be based on meeting total cash returned requirements. This joint venture financial model is often easier to explain than IRR hurdle-based templates as well.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Joint Venture Excel: Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping


$75.00
This template was crafted by a Financial Modeler, Accountant, & Consultant with over 10+ years of experience in developing Real Estate Underwriting tools. He has served 750+ clients, from small family offices to billion-dollar corporations.
Add to Cart
  

ABOUT THE AUTHOR

Author image
Additional documents from author: 188
Terms of usage (for all documents from this author)

I graduated in 2011 with a Bachelor's degree in Accounting and began my career as a financial analyst at a small chain of auto repair shops. After gaining valuable experience, I launched my own practice specializing in real estate underwriting, later expanding into general business modeling.

I honed my spreadsheet modeling expertise by completing over 400 projects on Upwork with a 100% success ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.
Bundle and save! You can save up to 70% with bundles!

View bundle(s)




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials

 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"I have used Flevy services for a number of years and have never, ever been disappointed. As a matter of fact, David and his team continue, time after time, to impress me with their willingness to assist and in the real sense of the word. I have concluded in fact "

– Roberto Pelliccia, Senior Executive in International Hospitality
 
"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I "

– Nishi Singh, Strategist and MD at NSP Consultants
 
"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting
 
"Flevy.com has proven to be an invaluable resource library to our Independent Management Consultancy, supporting and enabling us to better serve our enterprise clients.

The value derived from our [FlevyPro] subscription in terms of the business it has helped to gain far exceeds the investment made, making a subscription a no-brainer for any growing consultancy – or in-house strategy team."

– Dean Carlton, Chief Transformation Officer, Global Village Transformations Pty Ltd.
 
"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Senior Executive Director at Technology Transformation Advisory
 
"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so "

– Omar Hernán Montes Parra, CEO at Quantum SFE
 
"As a consultant requiring up to date and professional material that will be of value and use to my clients, I find Flevy a very reliable resource.

The variety and quality of material available through Flevy offers a very useful and commanding source for information. Using Flevy saves me time, enhances my expertise and ends up being a good decision."

– Dennis Gershowitz, Principal at DG Associates




Save with Bundles

This document is available as part of the following discounted bundle(s):


Your Recently Viewed Documents

Customers Also Bought These Documents


Customers Also Like These Documents

Related Management Topics


Joint Venture Cash Flow Management Alliances M&A (Mergers & Acquisitions) NPV Calculator Partnership Agreement Working Capital Management M&A Acquisition Strategy Valuation Mergers & Acquisitions Cost Reduction Cost Reduction Assessment Cost Management Business Resilience Cost Containment Cost Take-out Cost Cutting Organizational Resilience

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.